alter table problem add ESCALATE_DEPART1_ID int;
go
alter table problem add WRITER_USER_MANAGE_GROUP_ID int;
go
alter table [role] add ROLE_LEVEL int
go
update [role] set role_level=1 where ID=1
go
update [role] set role_level=1 where ID=2
go
update [role] set role_level=3 where ID=3
go
update [role] set role_level=3 where ID=4
go
update [role] set role_level=4 where ID=5
go
update [role] set role_level=4 where ID=6
go
update [role] set role_level=4 where ID=8
go
update [role] set role_level=5 where ID=9
go
update [role] set role_level=2 where ID=10
go
update [role] set role_level=3 where ID=11
go
update [role] set role_level=3 where ID=12
go
update [role] set role_level=4 where ID=13
go
update [role] set role_level=5 where ID=14
go
update [role] set role_level=6 where ID=15
go
update [role] set role_level=7 where ID=16
go
update [role] set role_level=8 where ID=17
